Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$LOGSTDBY

`V$LOGSTDBY` is deprecated.

Column | Datatype | Description
--- | --- | ---
`SERIAL#` | `NUMBER` | SQL Session serial number. This data is used when joining this view with the `V$SESSION` and `V$PX_SESSION` views.
`LOGSTDBY_ID` | `NUMBER` | Parallel query slave ID
`PID` | `VARCHAR2(12)` | Process ID of the SQL apply process
`TYPE` | `VARCHAR2(30)` | Indicates the task being performed by the process (`COORDINATOR`, `APPLIER`, `ANALYZER`, `READER`, `PREPARER`, or `BUILDER`)
`STATUS_CODE` | `NUMBER` | Status number (or Oracle error code) belonging to the STATUS message
`STATUS` | `VARCHAR2(256)` | Description of the current activity of the process
`HIGH_SCN` | `NUMBER` | Highest system change number (SCN) seen by the process. This column is used to confirm the progress of the individual process.